Select [InvoiceT].[Number], [invoiceT].[Date]from ((([InvoiceTDetail] LEFT JOIN [StockTransfer]ON ([InvoiceTDetail].[Id] = [StockTransfer].[InvoiceTDetailId] and [StockTransfer].[DBId] = 1))INNER JOIN [InvoiceT]ON ([InvoiceTDetail].[InvoiceTId] = [InvoiceT].[Id] and [InvoiceT].[DBId] = 1))INNER JOIN [Article]ON ([InvoiceTDetail].[ArticleId] = [Article].[Id] and [Article].[DBId] = 1))where [InvoiceTDetail].[DBId] = 1and [InvoiceTDetail].[ArticleId] in(Select OrgArticleId from articlecomponent where [DBId] = 1 and [DestArticleId] = 4 and [Sell] = 1)and [StockTransfer].[DBId] Is Nullorder … Continue reading Query Select client invoice details with missing stock movements for article components